SELECT p.iPostID, p.iPostType, p.iAdType, p.iUserType, p.strTitle, p.iSubType, p.iItemType, p.iPrice, p.iPriceUnit, json_unquote(p.jsonLocation->"$.city") AS city, p.jsonExtra, p.tmPosted, p.iShowImg, p.strImages, p.strVideos, p.strPostURL FROM posts p WHERE p.iActive=1 AND p.iPostType=4 AND iPostID IN (SELECT t.iPostID FROM posttext t WHERE t.iDomID=1 AND MATCH (t.strSearch) AGAINST ('on +sale +and +for +sale' IN BOOLEAN MODE)) AND iCityID IN (10783,10752,10478,10665,10445,10468,10540,10997,10226,10972,10618,10227,10643,10458,11116,10469,10779,10881,10709,11033,10942,10423,11013,10406,10467,10372,10169,11090,10497,10224,10597,10499,10664,10736,10913,10915,10788,10496,10281,10854,11010,10379,10555,10495,10290,10853,10447,10912,10621,10661,10536,10219,10388,10384,10462,10548,11042,11099,10872,10605,10507,10630,10809,10914,10974,10911,11031,10979,10655,10215,10904,10747,10987,10481,16119,16152,10584,10541,10926,10668,10873,10909,10400,10391,10477,10542,10203,11112,10599,10928,10808,10213,10782,10804,10940,11124,10895,10270,10461,10204,10450,10890,10297,10334,11015,10882,10319,10588,10347,10476,10574,10543,10631,10381,10772,10825,10695,11122,11035,10633,10739,10563,10420,10522,10578,10209,10698,10436,11032,10583,10228,10789,11059,10650,10479,10194,10651,10413,10396,10830,10234,10570,11126,10851,10394,10636,10996,10725,10358,10217,11043,10897,11006,10627,10675,10265,10261,10191,10823,10860,10941,10870,10852,10837,10408,10676,10276,10704,10781,10404,10755,10192,10807,10726,10691,11004,10729,10286,10836,10824,10437,11120,10943,10625,10271,10677,11022,10971,10652,10449,10220,16113,11053,10505,11113,10383,11034,10734,10523,10724,10233,11123,10629,10225,10392,10662,10769,10382,10603,11091,10666,11065,10745,11131,16112,10575,10268,10693,10991,10179,10444,10333,10443,10266,16144,10405,10898,10526,10535,9872,11027,10342,10316,10596,10407,10269,10829,9894,9846,10976,10919,10780,10567,10648,10759,10569,9908,16588,9884,9877,10947,11134,11108,10145,10903,10640,10013,10140,11130,10493,9962,10125,10032,10247,10515,10062,9932,11083,9876,10863,16589,10258,10568,13034,10508,10231,10378,10933,10063,10118,10212,10920,10361,10368,10504,9802,10302,10088,10338,10200,9856,10770,6955,9996,9967,10452,10528,9823,6901,10529,10116,10410,10426,10187,9939,6900,9816,11109,11093,6949,9859,10879,6850,9909,9862,6966,10369,10216,9850,10790,10395,11019,10433,10456,10910,10502,10008,9920,10994,11084,9919,10158,10325,9838,9868,10336,10753,10066,9983,10190,10259,9917,10080,10577,10337,10020,10771,9970,10424,10019,9809,10512,6984,10968,10072,9973,10427,10012,10134,11040,10029,10984,11008,10214,10082,10249,10455,10371,9875,9941,10847,9900,10037,10703,10067,9812,10028,9918,10491,10034,10871,11100,9866,11009,10151,10750,10604,9874,10815,10021,10749,10010,10961,10490,11117,10580,10803,10672,9929,10533,9848,10303,6867,10240,9820,10581,10530,10978,9832,10189,10995,10389,11014,9882,10756,10799,9867,10964,10241,9904,9995,10035,10494,10778,10858,16150,10160,10064,10126,9905,9931,9994,11048,9873,10038,10579,10834,11036,9921,10312,10498,10147,10766,9927,9930,10425,10030,9966,9936,6945,11094,10056,10253,10146,10133,9989,9914,10308,9841,10801,10740,10746,10081,10128,10120,9806,11041,6888,10923,10015,9961,10103,6932,10003,11125,6946,10208,10566,10123,10617,9965,10534,9813,10916,10086,10315,10079,10076,9839,10818,10243,10094,10050,10127,9979,10077,10016,9800,10014,10908,9940,10339,10161,10611,11097,9836,10990,9879,11000,9944,10157,10075,10309,10058,10731,10748,10222,10932,10057,9881,10300,10715,10051,10547,9992,9855,16256,10089,10150,10551,10757,10592,7007,10124,9969,10877,9896,10110,9885,10139,9807,10091,9844,10018,10166,10537,9883,9976,16249,10159,9901,10061,10401,10218,9968,10352,10025,11049,7010,9851,10223,9945,9971,10041,9963,10556,10531,9847,10242,10093,10861,6980,10148,11011,11081,9937,11003,10717,10002,9955,10023,10114,10438,10944,10730,6894,9915,10867,10831,9865,10143,10593,11089,9891,10354,10784,10868,10049,9869,9842,9982,9964,10068,10099,10112,11012,9890,10397,10689,11136,10022,9886,11001,10085,10119,10343,10009,10721,10135,10733,9821,9986,11045,6897,9974,9975,10483,10274,10045,9835,9997,10065,10084,6965,10963,10484,9824,10036,10351,10017,10104,10773,10706,10136,9817,9831,10229,9947,10835,9805,13030,10001,10639,16241,10083,10024,10138,10614,10967,10044,10697,10950,9871,10267,6889,10957,9827,11133,10539,9999,9980,10004,10071,9998,9808,10102,10105,10027,9926,9861,6986,10090,10096,10905,9814,10896,6995,10100,9864,10954,10453,10659,9988,10141,10833,10006,9863,9948,10680,9991,16581,10144,10107,10073,16512,10108,10154,9950,10109,10402,10679,10097,9898,10131,10162,9887,10129,10251,10545,10524,10510,13028,10723,10101,10087,9818,9826,9923,10305,16202,9981,9860,9977,9878,11052,6863,16128,16513,11095,6925,9987,16595,10142,10669,10095,10252,10299,10546,10291,9984,9938,10152,9830,9888,11121,10714,11057,10607,10332,16258,10048,9897,9978,10393,10059,9906,10149,9943,10098,7019,9852,10609,11064,10078,10047,9925,9857) ORDER BY FIELD(iCityID, 10783,10752,10478,10665,10445,10468,10540,10997,10226,10972,10618,10227,10643,10458,11116,10469,10779,10881,10709,11033,10942,10423,11013,10406,10467,10372,10169,11090,10497,10224,10597,10499,10664,10736,10913,10915,10788,10496,10281,10854,11010,10379,10555,10495,10290,10853,10447,10912,10621,10661,10536,10219,10388,10384,10462,10548,11042,11099,10872,10605,10507,10630,10809,10914,10974,10911,11031,10979,10655,10215,10904,10747,10987,10481,16119,16152,10584,10541,10926,10668,10873,10909,10400,10391,10477,10542,10203,11112,10599,10928,10808,10213,10782,10804,10940,11124,10895,10270,10461,10204,10450,10890,10297,10334,11015,10882,10319,10588,10347,10476,10574,10543,10631,10381,10772,10825,10695,11122,11035,10633,10739,10563,10420,10522,10578,10209,10698,10436,11032,10583,10228,10789,11059,10650,10479,10194,10651,10413,10396,10830,10234,10570,11126,10851,10394,10636,10996,10725,10358,10217,11043,10897,11006,10627,10675,10265,10261,10191,10823,10860,10941,10870,10852,10837,10408,10676,10276,10704,10781,10404,10755,10192,10807,10726,10691,11004,10729,10286,10836,10824,10437,11120,10943,10625,10271,10677,11022,10971,10652,10449,10220,16113,11053,10505,11113,10383,11034,10734,10523,10724,10233,11123,10629,10225,10392,10662,10769,10382,10603,11091,10666,11065,10745,11131,16112,10575,10268,10693,10991,10179,10444,10333,10443,10266,16144,10405,10898,10526,10535,9872,11027,10342,10316,10596,10407,10269,10829,9894,9846,10976,10919,10780,10567,10648,10759,10569,9908,16588,9884,9877,10947,11134,11108,10145,10903,10640,10013,10140,11130,10493,9962,10125,10032,10247,10515,10062,9932,11083,9876,10863,16589,10258,10568,13034,10508,10231,10378,10933,10063,10118,10212,10920,10361,10368,10504,9802,10302,10088,10338,10200,9856,10770,6955,9996,9967,10452,10528,9823,6901,10529,10116,10410,10426,10187,9939,6900,9816,11109,11093,6949,9859,10879,6850,9909,9862,6966,10369,10216,9850,10790,10395,11019,10433,10456,10910,10502,10008,9920,10994,11084,9919,10158,10325,9838,9868,10336,10753,10066,9983,10190,10259,9917,10080,10577,10337,10020,10771,9970,10424,10019,9809,10512,6984,10968,10072,9973,10427,10012,10134,11040,10029,10984,11008,10214,10082,10249,10455,10371,9875,9941,10847,9900,10037,10703,10067,9812,10028,9918,10491,10034,10871,11100,9866,11009,10151,10750,10604,9874,10815,10021,10749,10010,10961,10490,11117,10580,10803,10672,9929,10533,9848,10303,6867,10240,9820,10581,10530,10978,9832,10189,10995,10389,11014,9882,10756,10799,9867,10964,10241,9904,9995,10035,10494,10778,10858,16150,10160,10064,10126,9905,9931,9994,11048,9873,10038,10579,10834,11036,9921,10312,10498,10147,10766,9927,9930,10425,10030,9966,9936,6945,11094,10056,10253,10146,10133,9989,9914,10308,9841,10801,10740,10746,10081,10128,10120,9806,11041,6888,10923,10015,9961,10103,6932,10003,11125,6946,10208,10566,10123,10617,9965,10534,9813,10916,10086,10315,10079,10076,9839,10818,10243,10094,10050,10127,9979,10077,10016,9800,10014,10908,9940,10339,10161,10611,11097,9836,10990,9879,11000,9944,10157,10075,10309,10058,10731,10748,10222,10932,10057,9881,10300,10715,10051,10547,9992,9855,16256,10089,10150,10551,10757,10592,7007,10124,9969,10877,9896,10110,9885,10139,9807,10091,9844,10018,10166,10537,9883,9976,16249,10159,9901,10061,10401,10218,9968,10352,10025,11049,7010,9851,10223,9945,9971,10041,9963,10556,10531,9847,10242,10093,10861,6980,10148,11011,11081,9937,11003,10717,10002,9955,10023,10114,10438,10944,10730,6894,9915,10867,10831,9865,10143,10593,11089,9891,10354,10784,10868,10049,9869,9842,9982,9964,10068,10099,10112,11012,9890,10397,10689,11136,10022,9886,11001,10085,10119,10343,10009,10721,10135,10733,9821,9986,11045,6897,9974,9975,10483,10274,10045,9835,9997,10065,10084,6965,10963,10484,9824,10036,10351,10017,10104,10773,10706,10136,9817,9831,10229,9947,10835,9805,13030,10001,10639,16241,10083,10024,10138,10614,10967,10044,10697,10950,9871,10267,6889,10957,9827,11133,10539,9999,9980,10004,10071,9998,9808,10102,10105,10027,9926,9861,6986,10090,10096,10905,9814,10896,6995,10100,9864,10954,10453,10659,9988,10141,10833,10006,9863,9948,10680,9991,16581,10144,10107,10073,16512,10108,10154,9950,10109,10402,10679,10097,9898,10131,10162,9887,10129,10251,10545,10524,10510,13028,10723,10101,10087,9818,9826,9923,10305,16202,9981,9860,9977,9878,11052,6863,16128,16513,11095,6925,9987,16595,10142,10669,10095,10252,10299,10546,10291,9984,9938,10152,9830,9888,11121,10714,11057,10607,10332,16258,10048,9897,9978,10393,10059,9906,10149,9943,10098,7019,9852,10609,11064,10078,10047,9925,9857) ASC, p.tmPosted DESC LIMIT 24 OFFSET 24 on sale and for sale, For Sale Classifieds, Buy Used, Electronics, Computers, Tablets, Mobiles in North New Hyde Park, Page 2

Items for sale in North New Hyde Park - on sale and for sale

Show more results

By Using this website, you agree to Terms of Use & Privacy Policy. Got it